Text formatting in a cell

Clear format

You can quickly remove the text or format from the selected cell. To do that,

1. select a cell, a cell range with the mouse or the whole worksheet by pressing the Ctrl+A key combination,

   Note: you can also select multiple non-adjacent cells or cell ranges holding down the key while selecting cells / ranges with the mouse.

2. click the Clear icon on the Home tab tab of the top toolbar and select one of the available options:

   • use the All option if you wish to remove everything including the text, format, function etc;

   • use the Text option if you wish to remove the text from the selected range of cell range;

   • use the Format option if you wish to remove the format of the selected cell range. The text and all functions will remain;

   • use the Comments option if you wish to remove comments from the selected cell range;

   • use the Hyperlinks option if you wish to remove hyperlinks from the selected cell range.

   Note: All these options are also available in the right-click menu.

Copy cell format

1. select the cell / cell range with the required format by clicking or using the keyboard,

2. click the Copy style icon on the Home tab of the top toolbar, (the mouse pointer will look like this ),

3. select the cell / cell range to apply the required format to.

To apply the copied format to multiple non-adjacent cells or cell ranges,

1. select the cell / cell range with the required format by clicking or using the keyboard,

2. double-click the Copy style icon on the Home tab of the top toolbar, (the mouse pointer will look like this and the Copy style icon will remain selected: ),

3. click the required cells or select the cell ranges one by one to apply the same format to all of them,

4. to exit this mode, click the icon once again.